What is the best datatype for a column that is expected to store values up to 2 million?

  1. Home
  2. Back

Question:
What is the best datatype for a column that is expected to store values up to 2 million?

1.SMALLINT

2.TINYINT

3.MEDIUMINT

4.BIGINT

Posted Date:-2021-07-19 04:15:28

More MCQS Questions and answers

  1. Execution on a time activated basis according to a schedule is done by _______
  2. For which table does ‘REPAIR TABLE’ not work?
  3. How can the value of recently generated sequence number be obtained?
  4. How is a stored procedure invoked?
  5. How many files does each end of a client/server connection including SSL support use to set up secure communications?
  6. How would a stored function named PI() written in the database ‘sampdb’ be called?
  7. REPAIR TABLE does not work for _____
  8. Slow shutdown can be performed by setting innodb_fast_shutdown to ________
  9. The character that the MySQL client program recognizes as a statement delimiter is _______
  10. The column not returned by ‘OPTIMIZE TABLE’ is ______
  11. The command to see the warning messages is _______
  12. The datatype that stores the longest length of strings is _____
  13. The grant table scope columns that is case insensitive is _____
  14. The line that is not used to turn on the event scheduler is ______
  15. The line which is written at the top of the script to write a Perl script using CGI.pm is _______
  16. The log enabled by –relay-log-index is _____
  17. The mode used to turn on strict mode and all of the additional restrictions is ____
  18. The number of values returned from a stored procedure can be _____
  19. The privilege that must be given to the database to create a stored function or procedure is _____
  20. The recovery of data changes made since a given point in time is called ____
  21. The security context when a user creates a stored program that accesses sensitive data but forgets that other people who can invoke the object have the same access is ______
  22. The statement that is used to check the status of the event scheduler at runtime is _____
  23. The statement that performs key distribution analysis and stores the distribution for the named tables is _______
  24. The table that lists the column level privileges is ______
  25. The TLS protocol is _____
  26. The value of event_scheduler that enables checking status but not changing it at runtime is ______________
  27. To check if the data directory contains insecure files or directories, the command executed is _____________
  28. To perform consistency checks on a MyISAM table the statement is _____
  29. Triggers are not supported for ______
  30. What causes a replication master server to delete all the binary log files even if they are still in use?
  31. What does ‘abc’ || ‘xyz’, when PIPES_AS_CONCAT is enabled, result in?
  32. What does LAST_INSERT_ID() return when no AUTO_INCREMENT value has been generated during the current connection?
  33. What does the AUTO_INCREMENT sequences normally begin at?
  34. What does the expression ‘2 BETWEEN 2 AND 5’ result in?
  35. What enables the read and execute access to all users outside of mysql group.
  36. What is a synonym for CHARACTER SET?
  37. What is the best datatype for a column that is expected to store values up to 2 million?
  38. What is the Perl DBI?
  39. What is the size of the BIT type?
  40. What is the SQL mode to check for divide by zero error?
  41. What is the storage size in bytes required for the MEDIUMINT datatype?
  42. What is the synonym for REAL?
  43. What performs a key distribution analysis and stores the distribution for the named table or tables?
  44. Which of the following columns is not returned by ‘OPTIMIZE TABLE’?
  45. Which of these grant table scope columns is case insensitive?
  46. Which program is used as a utility for MyISAM table maintenance?
  47. Which table lists the accounts and the databases for which the privileges are provided?
  48. Which upgrade involves exporting existing data using mysqldump?
  49. Which upgrade involves shutting down the old MySQL version and replacing the old binaries?
  50. Which variable checks for the availability of SSL support?
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!